/*
	Created: Jonathan Turner
		On : 10/18/2013
Description: Update an employee's details
	Updates:
*/

ALTER PROCEDURE daycare.UpdateEmployee
  @EmployeeId INT
, @FirstName VARCHAR(100)
, @LastName VARCHAR(100)
, @PhoneNumber VARCHAR(15)
, @EmailAddress VARCHAR(100)
, @IsEmployed BIT
, @ImageId INT
AS 
  UPDATE  daycare.Employees
  SET     FirstName = @FirstName
        , LastName = @LastName
        , PhoneNumber = @PhoneNumber
        , EmailAddress = @EmailAddress
        , IsEmployed = @IsEmployed
        , ImageId = @ImageId
  WHERE   EmployeeId = @EmployeeId
  GO